1 <?xml version="1.0" encoding="utf-8"?>
2 <xs:schema id="hospitalDataSet3" targetNamespace="http://tempuri.org/hospitalDataSet3.xsd" xmlns:mstns="http://tempuri.org/hospitalDataSet3.xsd" xmlns="http://tempuri.org/hospitalDataSet3.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
3 <xs:annotation>
4 <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
5 <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
6 <Connections>
7 <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="hospitalConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="hospitalConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.HospitalManagementSystemCSharp.Properties.Settings.GlobalReference.Default.hospitalConnectionString" Provider="System.Data.SqlClient" />
8 </Connections>
9 <Tables>
10 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="checkoutTableAdapter" GeneratorDataComponentClassName="checkoutTableAdapter" Name="checkout" UserDataComponentName="checkoutTableAdapter">
11 <MainSource>
12 <DbSource ConnectionRef="hospitalConnectionString (Settings)" DbObjectName="dbo.checkout" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
13 <DeleteCommand>
14 <DbCommand CommandType="Text" ModifiedByUser="false">
15 <CommandText>DELETE FROM [dbo].[checkout] WHERE (([Id] = @Original_Id) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_gen = 1 AND [gen] IS NULL) OR ([gen] = @Original_gen)) AND ((@IsNull_age = 1 AND [age] IS NULL) OR ([age] = @Original_age)) AND ((@IsNull_contact = 1 AND [contact] IS NULL) OR ([contact] = @Original_contact)) AND ((@IsNull_addr = 1 AND [addr] IS NULL) OR ([addr] = @Original_addr)) AND ((@IsNull_disease = 1 AND [disease] IS NULL) OR ([disease] = @Original_disease)) AND ((@IsNull_date_in = 1 AND [date_in] IS NULL) OR ([date_in] = @Original_date_in)) AND ((@IsNull_date_out = 1 AND [date_out] IS NULL) OR ([date_out] = @Original_date_out)) AND ((@IsNull_build = 1 AND [build] IS NULL) OR ([build] = @Original_build)) AND ((@IsNull_r_no = 1 AND [r_no] IS NULL) OR ([r_no] = @Original_r_no)) AND ((@IsNull_r_type = 1 AND [r_type] IS NULL) OR ([r_type] = @Original_r_type)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_med_price = 1 AND [med_price] IS NULL) OR ([med_price] = @Original_med_price)) AND ((@IsNull_total = 1 AND [total] IS NULL) OR ([total] = @Original_total)))</CommandText>
16 <Parameters>
17 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
18 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
19 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
20 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_gen" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="gen" SourceColumnNullMapping="true" SourceVersion="Original" />
21 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_gen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="gen" SourceColumnNullMapping="false" SourceVersion="Original" />
22 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_age" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="age" SourceColumnNullMapping="true" SourceVersion="Original" />
23 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_age" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="age" SourceColumnNullMapping="false" SourceVersion="Original" />
24 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_contact" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="contact" SourceColumnNullMapping="true" SourceVersion="Original" />
25 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_contact" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="contact" SourceColumnNullMapping="false" SourceVersion="Original" />
26 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_addr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="addr" SourceColumnNullMapping="true" SourceVersion="Original" />
27 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_addr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="addr" SourceColumnNullMapping="false" SourceVersion="Original" />
28 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_disease" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="disease" SourceColumnNullMapping="true" SourceVersion="Original" />
29 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_disease" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="disease" SourceColumnNullMapping="false" SourceVersion="Original" />
30 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_date_in" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="date_in" SourceColumnNullMapping="true" SourceVersion="Original" />
31 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_date_in" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="date_in" SourceColumnNullMapping="false" SourceVersion="Original" />
32 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_date_out" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="date_out" SourceColumnNullMapping="true" SourceVersion="Original" />
33 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_date_out" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="date_out" SourceColumnNullMapping="false" SourceVersion="Original" />
34 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_build" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="build" SourceColumnNullMapping="true" SourceVersion="Original" />
35 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_build" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="build" SourceColumnNullMapping="false" SourceVersion="Original" />
36 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_r_no" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="r_no" SourceColumnNullMapping="true" SourceVersion="Original" />
37 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_r_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_no" SourceColumnNullMapping="false" SourceVersion="Original" />
38 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_r_type" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="r_type" SourceColumnNullMapping="true" SourceVersion="Original" />
39 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_r_type" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_type" SourceColumnNullMapping="false" SourceVersion="Original" />
40 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="true" SourceVersion="Original" />
41 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Original" />
42 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_med_price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="med_price" SourceColumnNullMapping="true" SourceVersion="Original" />
43 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_med_price" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="med_price" SourceColumnNullMapping="false" SourceVersion="Original" />
44 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_total" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="total" SourceColumnNullMapping="true" SourceVersion="Original" />
45 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_total" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="total" SourceColumnNullMapping="false" SourceVersion="Original" />
46 </Parameters>
47 </DbCommand>
48 </DeleteCommand>
49 <InsertCommand>
50 <DbCommand CommandType="Text" ModifiedByUser="false">
51 <CommandText>INSERT INTO [dbo].[checkout] ([name], [gen], [age], [contact], [addr], [disease], [date_in], [date_out], [build], [r_no], [r_type], [status], [med_price], [total]) VALUES (@name, @gen, @age, @contact, @addr, @disease, @date_in, @date_out, @build, @r_no, @r_type, @status, @med_price, @total);
52 SELECT Id, name, gen, age, contact, addr, disease, date_in, date_out, build, r_no, r_type, status, med_price, total FROM checkout WHERE (Id = SCOPE_IDENTITY())</CommandText>
53 <Parameters>
54 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
55 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@gen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="gen" SourceColumnNullMapping="false" SourceVersion="Current" />
56 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@age" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="age" SourceColumnNullMapping="false" SourceVersion="Current" />
57 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@contact" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="contact" SourceColumnNullMapping="false" SourceVersion="Current" />
58 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@addr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="addr" SourceColumnNullMapping="false" SourceVersion="Current" />
59 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@disease" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="disease" SourceColumnNullMapping="false" SourceVersion="Current" />
60 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@date_in" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="date_in" SourceColumnNullMapping="false" SourceVersion="Current" />
61 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@date_out" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="date_out" SourceColumnNullMapping="false" SourceVersion="Current" />
62 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@build" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="build" SourceColumnNullMapping="false" SourceVersion="Current" />
63 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@r_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_no" SourceColumnNullMapping="false" SourceVersion="Current" />
64 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@r_type" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_type" SourceColumnNullMapping="false" SourceVersion="Current" />
65 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
66 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@med_price" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="med_price" SourceColumnNullMapping="false" SourceVersion="Current" />
67 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@total" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="total" SourceColumnNullMapping="false" SourceVersion="Current" />
68 </Parameters>
69 </DbCommand>
70 </InsertCommand>
71 <SelectCommand>
72 <DbCommand CommandType="Text" ModifiedByUser="false">
73 <CommandText>SELECT Id, name, gen, age, contact, addr, disease, date_in, date_out, build, r_no, r_type, status, med_price, total FROM dbo.checkout</CommandText>
74 <Parameters />
75 </DbCommand>
76 </SelectCommand>
77 <UpdateCommand>
78 <DbCommand CommandType="Text" ModifiedByUser="false">
79 <CommandText>UPDATE [dbo].[checkout] SET [name] = @name, [gen] = @gen, [age] = @age, [contact] = @contact, [addr] = @addr, [disease] = @disease, [date_in] = @date_in, [date_out] = @date_out, [build] = @build, [r_no] = @r_no, [r_type] = @r_type, [status] = @status, [med_price] = @med_price, [total] = @total WHERE (([Id] = @Original_Id) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_gen = 1 AND [gen] IS NULL) OR ([gen] = @Original_gen)) AND ((@IsNull_age = 1 AND [age] IS NULL) OR ([age] = @Original_age)) AND ((@IsNull_contact = 1 AND [contact] IS NULL) OR ([contact] = @Original_contact)) AND ((@IsNull_addr = 1 AND [addr] IS NULL) OR ([addr] = @Original_addr)) AND ((@IsNull_disease = 1 AND [disease] IS NULL) OR ([disease] = @Original_disease)) AND ((@IsNull_date_in = 1 AND [date_in] IS NULL) OR ([date_in] = @Original_date_in)) AND ((@IsNull_date_out = 1 AND [date_out] IS NULL) OR ([date_out] = @Original_date_out)) AND ((@IsNull_build = 1 AND [build] IS NULL) OR ([build] = @Original_build)) AND ((@IsNull_r_no = 1 AND [r_no] IS NULL) OR ([r_no] = @Original_r_no)) AND ((@IsNull_r_type = 1 AND [r_type] IS NULL) OR ([r_type] = @Original_r_type)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_med_price = 1 AND [med_price] IS NULL) OR ([med_price] = @Original_med_price)) AND ((@IsNull_total = 1 AND [total] IS NULL) OR ([total] = @Original_total)));
80 SELECT Id, name, gen, age, contact, addr, disease, date_in, date_out, build, r_no, r_type, status, med_price, total FROM checkout WHERE (Id = @Id)</CommandText>
81 <Parameters>
82 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
83 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@gen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="gen" SourceColumnNullMapping="false" SourceVersion="Current" />
84 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@age" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="age" SourceColumnNullMapping="false" SourceVersion="Current" />
85 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@contact" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="contact" SourceColumnNullMapping="false" SourceVersion="Current" />
86 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@addr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="addr" SourceColumnNullMapping="false" SourceVersion="Current" />
87 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@disease" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="disease" SourceColumnNullMapping="false" SourceVersion="Current" />
88 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@date_in" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="date_in" SourceColumnNullMapping="false" SourceVersion="Current" />
89 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@date_out" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="date_out" SourceColumnNullMapping="false" SourceVersion="Current" />
90 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@build" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="build" SourceColumnNullMapping="false" SourceVersion="Current" />
91 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@r_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_no" SourceColumnNullMapping="false" SourceVersion="Current" />
92 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@r_type" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_type" SourceColumnNullMapping="false" SourceVersion="Current" />
93 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
94 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@med_price" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="med_price" SourceColumnNullMapping="false" SourceVersion="Current" />
95 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@total" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="total" SourceColumnNullMapping="false" SourceVersion="Current" />
96 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
97 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
98 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
99 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_gen" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="gen" SourceColumnNullMapping="true" SourceVersion="Original" />
100 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_gen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="gen" SourceColumnNullMapping="false" SourceVersion="Original" />
101 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_age" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="age" SourceColumnNullMapping="true" SourceVersion="Original" />
102 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_age" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="age" SourceColumnNullMapping="false" SourceVersion="Original" />
103 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_contact" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="contact" SourceColumnNullMapping="true" SourceVersion="Original" />
104 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_contact" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="contact" SourceColumnNullMapping="false" SourceVersion="Original" />
105 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_addr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="addr" SourceColumnNullMapping="true" SourceVersion="Original" />
106 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_addr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="addr" SourceColumnNullMapping="false" SourceVersion="Original" />
107 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_disease" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="disease" SourceColumnNullMapping="true" SourceVersion="Original" />
108 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_disease" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="disease" SourceColumnNullMapping="false" SourceVersion="Original" />
109 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_date_in" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="date_in" SourceColumnNullMapping="true" SourceVersion="Original" />
110 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_date_in" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="date_in" SourceColumnNullMapping="false" SourceVersion="Original" />
111 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_date_out" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="date_out" SourceColumnNullMapping="true" SourceVersion="Original" />
112 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_date_out" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="date_out" SourceColumnNullMapping="false" SourceVersion="Original" />
113 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_build" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="build" SourceColumnNullMapping="true" SourceVersion="Original" />
114 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_build" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="build" SourceColumnNullMapping="false" SourceVersion="Original" />
115 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_r_no" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="r_no" SourceColumnNullMapping="true" SourceVersion="Original" />
116 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_r_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_no" SourceColumnNullMapping="false" SourceVersion="Original" />
117 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_r_type" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="r_type" SourceColumnNullMapping="true" SourceVersion="Original" />
118 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_r_type" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_type" SourceColumnNullMapping="false" SourceVersion="Original" />
119 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="true" SourceVersion="Original" />
120 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Original" />
121 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_med_price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="med_price" SourceColumnNullMapping="true" SourceVersion="Original" />
122 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_med_price" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="med_price" SourceColumnNullMapping="false" SourceVersion="Original" />
123 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_total" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="total" SourceColumnNullMapping="true" SourceVersion="Original" />
124 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_total" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="total" SourceColumnNullMapping="false" SourceVersion="Original" />
125 <Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="Id" DataSourceName="[F:\Sem.4\C# Projects\Trials\HospitalManagementSystemCSharp\HospitalManagementSystemCSharp\HOSPITAL.MDF].dbo.checkout" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
126 </Parameters>
127 </DbCommand>
128 </UpdateCommand>
129 </DbSource>
130 </MainSource>
131 <Mappings>
132 <Mapping SourceColumn="Id" DataSetColumn="Id" />
133 <Mapping SourceColumn="name" DataSetColumn="name" />
134 <Mapping SourceColumn="gen" DataSetColumn="gen" />
135 <Mapping SourceColumn="age" DataSetColumn="age" />
136 <Mapping SourceColumn="contact" DataSetColumn="contact" />
137 <Mapping SourceColumn="addr" DataSetColumn="addr" />
138 <Mapping SourceColumn="disease" DataSetColumn="disease" />
139 <Mapping SourceColumn="date_in" DataSetColumn="date_in" />
140 <Mapping SourceColumn="date_out" DataSetColumn="date_out" />
141 <Mapping SourceColumn="build" DataSetColumn="build" />
142 <Mapping SourceColumn="r_no" DataSetColumn="r_no" />
143 <Mapping SourceColumn="r_type" DataSetColumn="r_type" />
144 <Mapping SourceColumn="status" DataSetColumn="status" />
145 <Mapping SourceColumn="med_price" DataSetColumn="med_price" />
146 <Mapping SourceColumn="total" DataSetColumn="total" />
147 </Mappings>
148 <Sources />
149 </TableAdapter>
150 </Tables>
151 <Sources />
152 </DataSource>
153 </xs:appinfo>
154 </xs:annotation>
155 <xs:element name="hospitalDataSet3" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="hospitalDataSet3" msprop:Generator_UserDSName="hospitalDataSet3">
156 <xs:complexType>
157 <xs:choice minOccurs="0" maxOccurs="unbounded">
158 <xs:element name="checkout" msprop:Generator_TableClassName="checkoutDataTable" msprop:Generator_TableVarName="tablecheckout" msprop:Generator_TablePropName="checkout" msprop:Generator_RowDeletingName="checkoutRowDeleting" msprop:Generator_RowChangingName="checkoutRowChanging" msprop:Generator_RowEvHandlerName="checkoutRowChangeEventHandler" msprop:Generator_RowDeletedName="checkoutRowDeleted" msprop:Generator_UserTableName="checkout" msprop:Generator_RowChangedName="checkoutRowChanged" msprop:Generator_RowEvArgName="checkoutRowChangeEvent" msprop:Generator_RowClassName="checkoutRow">
159 <xs:complexType>
160 <xs:sequence>
161 <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
162 <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name" minOccurs="0">
163 <xs:simpleType>
164 <xs:restriction base="xs:string">
165 <xs:maxLength value="50" />
166 </xs:restriction>
167 </xs:simpleType>
168 </xs:element>
169 <xs:element name="gen" msprop:Generator_ColumnVarNameInTable="columngen" msprop:Generator_ColumnPropNameInRow="gen" msprop:Generator_ColumnPropNameInTable="genColumn" msprop:Generator_UserColumnName="gen" minOccurs="0">
170 <xs:simpleType>
171 <xs:restriction base="xs:string">
172 <xs:maxLength value="50" />
173 </xs:restriction>
174 </xs:simpleType>
175 </xs:element>
176 <xs:element name="age" msprop:Generator_ColumnVarNameInTable="columnage" msprop:Generator_ColumnPropNameInRow="age" msprop:Generator_ColumnPropNameInTable="ageColumn" msprop:Generator_UserColumnName="age" minOccurs="0">
177 <xs:simpleType>
178 <xs:restriction base="xs:string">
179 <xs:maxLength value="50" />
180 </xs:restriction>
181 </xs:simpleType>
182 </xs:element>
183 <xs:element name="contact" msprop:Generator_ColumnVarNameInTable="columncontact" msprop:Generator_ColumnPropNameInRow="contact" msprop:Generator_ColumnPropNameInTable="contactColumn" msprop:Generator_UserColumnName="contact" minOccurs="0">
184 <xs:simpleType>
185 <xs:restriction base="xs:string">
186 <xs:maxLength value="50" />
187 </xs:restriction>
188 </xs:simpleType>
189 </xs:element>
190 <xs:element name="addr" msprop:Generator_ColumnVarNameInTable="columnaddr" msprop:Generator_ColumnPropNameInRow="addr" msprop:Generator_ColumnPropNameInTable="addrColumn" msprop:Generator_UserColumnName="addr" minOccurs="0">
191 <xs:simpleType>
192 <xs:restriction base="xs:string">
193 <xs:maxLength value="50" />
194 </xs:restriction>
195 </xs:simpleType>
196 </xs:element>
197 <xs:element name="disease" msprop:Generator_ColumnVarNameInTable="columndisease" msprop:Generator_ColumnPropNameInRow="disease" msprop:Generator_ColumnPropNameInTable="diseaseColumn" msprop:Generator_UserColumnName="disease" minOccurs="0">
198 <xs:simpleType>
199 <xs:restriction base="xs:string">
200 <xs:maxLength value="50" />
201 </xs:restriction>
202 </xs:simpleType>
203 </xs:element>
204 <xs:element name="date_in" msprop:Generator_ColumnVarNameInTable="columndate_in" msprop:Generator_ColumnPropNameInRow="date_in" msprop:Generator_ColumnPropNameInTable="date_inColumn" msprop:Generator_UserColumnName="date_in" minOccurs="0">
205 <xs:simpleType>
206 <xs:restriction base="xs:string">
207 <xs:maxLength value="50" />
208 </xs:restriction>
209 </xs:simpleType>
210 </xs:element>
211 <xs:element name="date_out" msprop:Generator_ColumnVarNameInTable="columndate_out" msprop:Generator_ColumnPropNameInRow="date_out" msprop:Generator_ColumnPropNameInTable="date_outColumn" msprop:Generator_UserColumnName="date_out" minOccurs="0">
212 <xs:simpleType>
213 <xs:restriction base="xs:string">
214 <xs:maxLength value="50" />
215 </xs:restriction>
216 </xs:simpleType>
217 </xs:element>
218 <xs:element name="build" msprop:Generator_ColumnVarNameInTable="columnbuild" msprop:Generator_ColumnPropNameInRow="build" msprop:Generator_ColumnPropNameInTable="buildColumn" msprop:Generator_UserColumnName="build" minOccurs="0">
219 <xs:simpleType>
220 <xs:restriction base="xs:string">
221 <xs:maxLength value="50" />
222 </xs:restriction>
223 </xs:simpleType>
224 </xs:element>
225 <xs:element name="r_no" msprop:Generator_ColumnVarNameInTable="columnr_no" msprop:Generator_ColumnPropNameInRow="r_no" msprop:Generator_ColumnPropNameInTable="r_noColumn" msprop:Generator_UserColumnName="r_no" minOccurs="0">
226 <xs:simpleType>
227 <xs:restriction base="xs:string">
228 <xs:maxLength value="50" />
229 </xs:restriction>
230 </xs:simpleType>
231 </xs:element>
232 <xs:element name="r_type" msprop:Generator_ColumnVarNameInTable="columnr_type" msprop:Generator_ColumnPropNameInRow="r_type" msprop:Generator_ColumnPropNameInTable="r_typeColumn" msprop:Generator_UserColumnName="r_type" minOccurs="0">
233 <xs:simpleType>
234 <xs:restriction base="xs:string">
235 <xs:maxLength value="50" />
236 </xs:restriction>
237 </xs:simpleType>
238 </xs:element>
239 <xs:element name="status" msprop:Generator_ColumnVarNameInTable="columnstatus" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_ColumnPropNameInTable="statusColumn" msprop:Generator_UserColumnName="status" minOccurs="0">
240 <xs:simpleType>
241 <xs:restriction base="xs:string">
242 <xs:maxLength value="50" />
243 </xs:restriction>
244 </xs:simpleType>
245 </xs:element>
246 <xs:element name="med_price" msprop:Generator_ColumnVarNameInTable="columnmed_price" msprop:Generator_ColumnPropNameInRow="med_price" msprop:Generator_ColumnPropNameInTable="med_priceColumn" msprop:Generator_UserColumnName="med_price" minOccurs="0">
247 <xs:simpleType>
248 <xs:restriction base="xs:string">
249 <xs:maxLength value="50" />
250 </xs:restriction>
251 </xs:simpleType>
252 </xs:element>
253 <xs:element name="total" msprop:Generator_ColumnVarNameInTable="columntotal" msprop:Generator_ColumnPropNameInRow="total" msprop:Generator_ColumnPropNameInTable="totalColumn" msprop:Generator_UserColumnName="total" minOccurs="0">
254 <xs:simpleType>
255 <xs:restriction base="xs:string">
256 <xs:maxLength value="50" />
257 </xs:restriction>
258 </xs:simpleType>
259 </xs:element>
260 </xs:sequence>
261 </xs:complexType>
262 </xs:element>
263 </xs:choice>
264 </xs:complexType>
265 <xs:unique name="Constraint1" msdata:PrimaryKey="true">
266 <xs:selector xpath=".//mstns:checkout" />
267 <xs:field xpath="mstns:Id" />
268 </xs:unique>
269 </xs:element>
270 </xs:schema>
